package com.fox0g.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.fox0g.pojo.Queuecount;
import org.apache.ibatis.annotations.*;

import java.time.LocalTime;
import java.util.List;

/**
* @author 86176
* @description 针对表【queuecount(排队人数统计)】的数据库操作Mapper
* @createDate 2024-07-04 10:34:25
* @Entity com.fox0g.pojo.Queuecount
*/

@Mapper
public interface QueuecountMapper extends BaseMapper<Queuecount> {
    @Insert("insert into queue.queuecount(queuecount.num,queuecount.create_time)" +
            " values (#{num},#{createTime})")
    int insert(Queuecount queuecount) ;

    @Select("select id,num,create_time from queue.queuecount order by id desc ")
    List<Queuecount> allData();

    @Update("update queue.queuecount set queuecount.num = #{num}, create_time = #{createTime} where id = #{id}")
    int inputupdate(@Param("id") int id,@Param("num") int num,@Param("createTime") LocalTime localTime);
}




